﻿<?xml version="1.0" encoding="utf-8" ?>
<automailic>
  <configSection name="demo">
    <smtp server="smtp.upcmail.nl" port="25" />
    <database connectionType="ODBC" connectionString="DSN=UGPlatform;Uid=uguser;Pwd=uguser;" />
    <sql tokenDelimiter="$">
      <items>select UserID, Email, UserName from Users;</items>
      <onSuccess>update Users set Email=Email where UserID=$UserID$;</onSuccess>
      <onError>update Users set UserName=UserName where UserID=$UserID$;</onError>
    </sql>
    <mail type="HTML" from="info@automailic.com" to="info@automailic.com" subject="This is automatic mail to $UserName$!">
      <![CDATA[
<html>
  <head>
    <title>This is the title</title>
  </head>
  <body>
    <h1>This is the header to $UserName$</h1>
    <p>
      This is the body paragraph. Mail to: $Email$<br />
    </p>
  </body>
</html>
      ]]>
    </mail>
  </configSection>
</automailic>
